set hive.exec.dynamic.partition=true; -- 动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=20; --每天生成 20 个分区
set hive.exec.max.dynamic.partitions.pernode=20; --每天生成 20 个分区

insert overwrite table jms_dim.dim_sys_network_delivery_log_dt
select id
`id`
,`network_id`
,`delivery_points`
,`delivery_transfer_centers`
,`distribution_points`
,`delivery_centers`
,`delivery_id`
,`delivery_relationship_id`
,`is_distribution`
,`create_by`
,`create_by_name`
,`create_time`
,`update_time`
,`is_latest`
,`staff_code`
,dt
from jms_ods.sys_network_delivery_log
where dt='{{ execution_date | cst_ds }}'